The Format of dbCGI Files

dbCGI files are just like standard HTML files, except that thefollowing are recognised:The SQL subcommands are:The formatting escapes are:The %[...%], %{...%} and %(...%) sequences may all be nested.

Below is the layout of a sample dbCGI file for Informix.

<TITLE>CorVu dbCGI for Informix Test</TITLE> <sql init> INFORMIXDIR=/usr/informix SQLEXEC=/usr/informix/lib/sqlturbo TBCONFIG=tbconfig </sql> <sql connect conn1> DATABASE=stores </sql> <sql format> %[!8:<H1>%8d</H1>%] %[!7,8:<H2>%7d</H2>%] %[!7,8,9:<H3>%9d</H3>%] <H4>%4d</H4> %3d %2d<BR> %5d<BR> %6(%6d<BR>%) %10d<BR> </sql> <sql query conn1> select * from customer order by state, city, zipcode </sql> <sql disconnect conn1> </sql> <sql uninit> <sql>The query above accesses the customers table from the Informix sales demonstrationdatabase and prints a list with breaks by state, city and zipcode (columns 8, 7 and9). Column 6, which contains an optional second address line, is only displayed ifit is populated.